MySQL replication delaying issue

------_=_NextPart_001_01C8788F.317F0FA7
Content-Type: multipart/alternative;
boundary="----_=_NextPart_002_01C8788F.317F0FA7"


------_=_NextPart_002_01C8788F.317F0FA7
Content-Type: text/plain;
charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

=0AHello Everybody, =0AWe have 6 multi-m=
aster MySql instances within a LAN , that are replicating is a sequent=
ial manner. Server Environment : Six identical Linux Enterprise=
version 4 running, servers with having MySQL version 6. =0A=
we are using "MySQL multi-master replication" method for database repl=
ication. =0AThere is a delay (5-7 minutes) of that d=
ata replication process. =0AWe notice that it's because of MySQL=
table locking. =0AYour comments are highly apprecia=
ted. Many thanks in advance and be=
st regards, =0ALasitha Alawatta Applicati=
on Developer Destinations of the World Holding Establishment =0D=
=0AP O Box: 19950 Dubai, United Arab Emirates ( Ph +9=
71 4 295 8510 (Board) / 1464 (Ext.) 7 Fax +971 4 295 8910 +=
lasitha.a@dotw.com =0A w.dotw.com/> DOTW DISCLAIMER: This =
e-mail and any attachments are strictly confidential and intended for the a=
ddressee only. If you are not the named addressee you must not disclose, co=
py or take any action in reliance of this transmission and you should =
notify us as soon as possible. If you have received it in error, please con=
tact the message sender immediately. This e-mail and any attachments a=
re believed to be free from viruses but it is your responsibility to carry =
out all necessary virus checks and DOTW accepts no liability in connec=
tion therewith. =0AThis e-mail and all other electronic (includi=
ng voice) communications from the sender's company are for informational pu=
rposes only. No such communication is intended by the sender to const=
itute either an electronic record or an electronic signature or to constitu=
te any agreement by the sender to conduct a transaction by electronic means=
. =0A
------_=_NextPart_002_01C8788F.317F0FA7
Content-Type: text/html;
charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

osoft-com:office:office" xmlns:w=3D"urn:schemas-microsoft-com:office:word" =
xmlns:x=3D"urn:schemas-microsoft-com:office:excel" xmlns:p=3D"urn:schemas-m=
icrosoft-com:office:powerpoint" xmlns:a=3D"urn:schemas-microsoft-com:office=
:access" xmlns:dt=3D"uuid:C2F41010-65B3-11d1-A29F-00AA00C14882" xmlns:s=3D"=
uuid:BDC6E3F0-6DA3-11d1-A2A3-00AA00C14882" xmlns:rs=3D"urn:schemas-microsof=
t-com:rowset" xmlns:z=3D"#RowsetSchema" xmlns:b=3D"urn:schemas-microsoft-co=
m:office:publisher" xmlns:ss=3D"urn:schemas-microsoft-com:office:spreadshee=
t" xmlns:c=3D"urn:schemas-microsoft-com:office:component:spread sheet" xmlns=
:oa=3D"urn:schemas-microsoft-com:office:activation" xmlns:html=3D"http://ww=
w.w3.org/TR/REC-html40" xmlns:q=3D"http://schemas.xmlsoap.org/soap/envelope=
/" xmlns:D=3D"DAV:" xmlns:x2=3D"http://schemas.microsoft.com/office/excel/2=
003/xml" xmlns:ois=3D"http://schemas.microsoft.com/sharepoint/soap/oi s/" xm=
lns:dir=3D"http://schemas.microsoft.com/sharepoint/soap/dire ctory/" xmlns:d=
s=3D"http://www.w3.org/2000/09/xmldsig#" xmlns:dsp=3D"http://schemas.micros=
oft.com/sharepoint/dsp" xmlns:udc=3D"http://schemas.microsoft.com/data/udc"=
xmlns:xsd=3D"http://www.w3.org/2001/XMLSchema" xmlns:sub=3D"http://schemas=
microsoft.com/sharepoint/soap/2002/1/alerts/" xmlns:ec=3D"http://www.w3.=
org/2001/04/xmlenc#" xmlns:sp=3D"http://schemas.microsoft.com/sharepoint/" =
xmlns:sps=3D"http://schemas.microsoft.com/sharepoint/soap/" xmlns:xsi=3D"ht=
tp://www.w3.org/2001/XMLSchema-instance" xmlns:udcxf=3D"http://schemas.micr=
osoft.com/data/udc/xmlfile" xmlns:wf=3D"http://schemas.microsoft.com/sharep=
oint/soap/workflow/" xmlns:mver=3D"http://schemas.openxmlformats.org/markup=
-compatibility/2006" xmlns:m=3D"http://schemas.microsoft.com/office/2004/12=
/omml" xmlns:mrels=3D"http://schemas.openxmlformats.org/package/200 6/relati=
onships" xmlns:ex12t=3D"http://schemas.microsoft.com/exchange/service s/2006=
/types" xmlns:ex12m=3D"http://schemas.microsoft.com/exchange/service s/2006/=
messages" xmlns=3D"http://www.w3.org/TR/REC-html40"> =
=0D=
=0A=0D=
=0A =
link=3Dpurple>

Re: MySQL replication delaying issue

On Tue, Feb 26, 2008 at 10:49 AM, Lasitha Alawatta wrote:
> Hello Everybody,
>
> We have 6 multi-master MySql instances within a LAN , that are replicating
> is a sequential manner.
>
> Server Environment : Six identical Linux Enterprise version 4 running,
> servers with having MySQL version 6.
>
> we are using "MySQL multi-master replication" method for database
> replication.
>
> There is a delay (5-7 minutes) of that data replication process. We notice that it's because of MySQL table locking.
>
> Your comments are highly appreciated.

Ask on a MySQL list. It has nothing to do with PHP.

http://lists.mysql.com/

Specifically: Replication - http://lists.mysql.com/replication

--


Daniel P. Brown
Senior Unix Geek


--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

RES: MySQL replication delaying issue

------=_NextPart_000_00CC_01C8787C.ED5508F0
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

Not trying to be an ass, but wouldn't you get better answers if you =
asked in
a MySQL list?
=20
I work with PHP, but have near to 0 experience with MySQL.

_____ =20

De: Lasitha Alawatta [mailto:Lasitha.A@dotw.com]=20
Enviada em: ter=E7a-feira, 26 de fevereiro de 2008 12:50
Para: php-db@lists.php.net; patg@patg.net; phpresource@yahoogroups.com
Assunto: [PHP-DB] MySQL replication delaying issue
Prioridade: Alta



=20

Hello Everybody,

=20

We have 6 multi-master MySql instances within a LAN , that are =
replicating
is a sequential manner.

Server Environment : Six identical Linux Enterprise version 4 running,
servers with having MySQL version 6.=20

we are using =93MySQL multi-master replication=94 method for database
replication.

=20

There is a delay (5-7 minutes) of that data replication process.=20

We notice that it=92s because of MySQL table locking.

=20

Your comments are highly appreciated.

=20

=20

Many thanks in advance and best regards,

=20

Lasitha Alawatta

Application Developer

Destinations of the World Holding Establishment

P O Box: 19950

Dubai, United Arab Emirates

( Ph +971 4 295 8510 (Board) / 1464 (Ext.)

7 Fax +971 4 295 8910
+ lasitha.a@dotw.com=20

cid:image002.jpg@01C7A7A4.0AC70A00

=20




DOTW DISCLAIMER:

This e-mail and any attachments are strictly confidential and intended =
for
the addressee only. If you are not the named addressee you must not
disclose, copy or take
any action in reliance of this transmission and you should notify us as =
soon
as possible. If you have received it in error, please contact the =
message
sender immediately.
This e-mail and any attachments are believed to be free from viruses but =
it
is your responsibility to carry out all necessary virus checks and DOTW
accepts no liability
in connection therewith.=20

This e-mail and all other electronic (including voice) communications =
from
the sender's company are for informational purposes only. No such
communication is intended
by the sender to constitute either an electronic record or an electronic
signature or to constitute any agreement by the sender to conduct a
transaction by electronic means.
=09

------=_NextPart_000_00CC_01C8787C.ED5508F0--

RES: MySQL replication delaying issue

------=_NextPart_000_00ED_01C8787E.63145B30
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

I did not say: do not ask on this list.
=20
I said: you would get BETTER answers if you asked on a MySQL list.

_____ =20

De: Lasitha Alawatta [mailto:Lasitha.A@dotw.com]=20
Enviada em: ter=E7a-feira, 26 de fevereiro de 2008 13:47
Para: Thiago Pojda
Assunto: RE: [PHP-DB] MySQL replication delaying issue



=20

Hay,=20

If U don=92t know about that then u can ignore that mail. U need not to =
answer
each and every mails in this list.

MOST of the PHP developer are using MYSQL as backend.=20

=20

That=92s Y I sent that message to phpresources list also.

=20

=20

=20

=20

=20

From: Thiago Pojda [mailto:thiago.pojda@softpartech.com.br]=20
Sent: Tuesday, February 26, 2008 8:39 PM
To: Lasitha Alawatta; php-db@lists.php.net; patg@patg.net;
phpresource@yahoogroups.com
Subject: RES: [PHP-DB] MySQL replication delaying issue

=20

Not trying to be an ass, but wouldn't you get better answers if you =
asked in
a MySQL list?

=20

I work with PHP, but have near to 0 experience with MySQL.

=20

_____ =20

De: Lasitha Alawatta [mailto:Lasitha.A@dotw.com]=20
Enviada em: ter=E7a-feira, 26 de fevereiro de 2008 12:50
Para: php-db@lists.php.net; patg@patg.net; phpresource@yahoogroups.com
Assunto: [PHP-DB] MySQL replication delaying issue
Prioridade: Alta

=20

Hello Everybody,

=20

We have 6 multi-master MySql instances within a LAN , that are =
replicating
is a sequential manner.

Server Environment : Six identical Linux Enterprise version 4 running,
servers with having MySQL version 6.=20

we are using =93MySQL multi-master replication=94 method for database
replication.

=20

There is a delay (5-7 minutes) of that data replication process.=20

We notice that it=92s because of MySQL table locking.

=20

Your comments are highly appreciated.

=20

=20

Many thanks in advance and best regards,

=20

Lasitha Alawatta

Application Developer

Destinations of the World Holding Establishment

P O Box: 19950

Dubai, United Arab Emirates

( Ph +971 4 295 8510 (Board) / 1464 (Ext.)

7 Fax +971 4 295 8910
+ lasitha.a@dotw.com=20

cid:image002.jpg@01C7A7A4.0AC70A00

=20

=20



DOTW DISCLAIMER:

This e-mail and any attachments are strictly confidential and intended =
for
the addressee only. If you are not the named addressee you must not
disclose, copy or take
any action in reliance of this transmission and you should notify us as =
soon
as possible. If you have received it in error, please contact the =
message
sender immediately.
This e-mail and any attachments are believed to be free from viruses but =
it
is your responsibility to carry out all necessary virus checks and DOTW
accepts no liability
in connection therewith.=20

This e-mail and all other electronic (including voice) communications =
from
the sender's company are for informational purposes only. No such
communication is intended
by the sender to constitute either an electronic record or an electronic
signature or to constitute any agreement by the sender to conduct a
transaction by electronic means.

=20


------=_NextPart_000_00ED_01C8787E.63145B30--

RE: MySQL replication delaying issue

------=_NextPartTM-000-380f9c72-dac4-4527-8ddf-68fdf1181ec7
Content-Type: multipart/alternative;
boundary="----_=_NextPart_001_01C8789F.27768C02"

------_=_NextPart_001_01C8789F.27768C02
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

=20

Oky, Sorry for that.. J

=20

=20

From: Thiago Pojda [mailto:thiago.pojda@softpartech.com.br]=20
Sent: Tuesday, February 26, 2008 8:49 PM
To: Lasitha Alawatta
Cc: php-db@lists.php.net
Subject: RES: [PHP-DB] MySQL replication delaying issue

=20

I did not say: do not ask on this list.

=20

I said: you would get BETTER answers if you asked on a MySQL list.

=20

________________________________

De: Lasitha Alawatta [mailto:Lasitha.A@dotw.com]=20
Enviada em: ter=E7a-feira, 26 de fevereiro de 2008 13:47
Para: Thiago Pojda
Assunto: RE: [PHP-DB] MySQL replication delaying issue

=20

Hay,=20

If U don't know about that then u can ignore that mail. U need not to =
answer each and every mails in this list.

MOST of the PHP developer are using MYSQL as backend.=20

=20

That's Y I sent that message to phpresources list also.

=20

=20

=20

=20

=20

From: Thiago Pojda [mailto:thiago.pojda@softpartech.com.br]=20
Sent: Tuesday, February 26, 2008 8:39 PM
To: Lasitha Alawatta; php-db@lists.php.net; patg@patg.net; =
phpresource@yahoogroups.com
Subject: RES: [PHP-DB] MySQL replication delaying issue

=20

Not trying to be an ass, but wouldn't you get better answers if you =
asked in a MySQL list?

=20

I work with PHP, but have near to 0 experience with MySQL.

=20

________________________________

De: Lasitha Alawatta [mailto:Lasitha.A@dotw.com]=20
Enviada em: ter=E7a-feira, 26 de fevereiro de 2008 12:50
Para: php-db@lists.php.net; patg@patg.net; phpresource@yahoogroups.com
Assunto: [PHP-DB] MySQL replication delaying issue
Prioridade: Alta

=20

Hello Everybody,

=20

We have 6 multi-master MySql instances within a LAN , that are =
replicating is a sequential manner.

Server Environment : Six identical Linux Enterprise version 4 running, =
servers with having MySQL version 6.=20

we are using "MySQL multi-master replication" method for database =
replication.

=20

There is a delay (5-7 minutes) of that data replication process.=20

We notice that it's because of MySQL table locking.

=20

Your comments are highly appreciated.

=20

=20

Many thanks in advance and best regards,

=20

Lasitha Alawatta

Application Developer

Destinations of the World Holding Establishment

P O Box: 19950

Dubai, United Arab Emirates

( Ph +971 4 295 8510 (Board) / 1464 (Ext.)

7 Fax +971 4 295 8910
+ lasitha.a@dotw.com=20

cid:image002.jpg@01C7A7A4.0AC70A00 =20

=20

=20


DOTW DISCLAIMER:

This e-mail and any attachments are strictly confidential and intended =
for the addressee only. If you are not the named addressee you must not =
disclose, copy or take
any action in reliance of this transmission and you should notify us as =
soon as possible. If you have received it in error, please contact the =
message sender immediately.
This e-mail and any attachments are believed to be free from viruses but =
it is your responsibility to carry out all necessary virus checks and =
DOTW accepts no liability
in connection therewith.=20

This e-mail and all other electronic (including voice) communications =
from the sender's company are for informational purposes only. No such =
communication is intended
by the sender to constitute either an electronic record or an electronic =
signature or to constitute any agreement by the sender to conduct a =
transaction by electronic means.

=20


------_=_NextPart_001_01C8789F.27768C02
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

charset=3Diso-8859-1">
xmlns:o=3D"urn:schemas-microsoft-com:office:office" =
xmlns:w=3D"urn:schemas-microsoft-com:office:word" =
xmlns:x=3D"urn:schemas-microsoft-com:office:excel" =
xmlns:p=3D"urn:schemas-microsoft-com:office:powerpoint" =
xmlns:a=3D"urn:schemas-microsoft-com:office:access" =
xmlns:dt=3D"uuid:C2F41010-65B3-11d1-A29F-00AA00C14882" =
xmlns:s=3D"uuid:BDC6E3F0-6DA3-11d1-A2A3-00AA00C14882" =
xmlns:rs=3D"urn:schemas-microsoft-com:rowset" xmlns:z=3D"#RowsetSchema" =
xmlns:b=3D"urn:schemas-microsoft-com:office:publisher" =
xmlns:ss=3D"urn:schemas-microsoft-com:office:spreadsheet" =
xmlns:c=3D"urn:schemas-microsoft-com:office:component:spread sheet" =
xmlns:oa=3D"urn:schemas-microsoft-com:office:activation" =
xmlns:html=3D"http://www.w3.org/TR/REC-html40" =
xmlns:q=3D"http://schemas.xmlsoap.org/soap/envelope/" xmlns:D=3D"DAV:" =
xmlns:x2=3D"http://schemas.microsoft.com/office/excel/2003/x ml" =
xmlns:ois=3D"http://schemas.microsoft.com/sharepoint/soap/oi s/" =
xmlns:dir=3D"http://schemas.microsoft.com/sharepoint/soap/di rectory/" =
xmlns:ds=3D"http://www.w3.org/2000/09/xmldsig#" =
xmlns:dsp=3D"http://schemas.microsoft.com/sharepoint/dsp" =
xmlns:udc=3D"http://schemas.microsoft.com/data/udc" =
xmlns:xsd=3D"http://www.w3.org/2001/XMLSchema" =
xmlns:sub=3D"http://schemas.microsoft.com/sharepoint/soap/20 02/1/alerts/"=
xmlns:ec=3D"http://www.w3.org/2001/04/xmlenc#" =
xmlns:sp=3D"http://schemas.microsoft.com/sharepoint/" =
xmlns:sps=3D"http://schemas.microsoft.com/sharepoint/soap/" =
xmlns:xsi=3D"http://www.w3.org/2001/XMLSchema-instance" =
xmlns:udcxf=3D"http://schemas.microsoft.com/data/udc/xmlfile " =
xmlns:wf=3D"http://schemas.microsoft.com/sharepoint/soap/wor kflow/" =
xmlns:mver=3D"http://schemas.openxmlformats.org/markup-compa tibility/2006=
" xmlns:m=3D"http://schemas.microsoft.com/office/2004/12/omml" =
xmlns:mrels=3D"http://schemas.openxmlformats.org/package/200 6/relationshi=
ps" =
xmlns:ex12t=3D"http://schemas.microsoft.com/exchange/service s/2006/types"=
=
xmlns:ex12m=3D"http://schemas.microsoft.com/exchange/service s/2006/messag=
es" xmlns=3D"http://www.w3.org/TR/REC-html40">